Dataset info
| Number of variables | 21 |
|---|---|
| Number of observations | 179078 |
| Missing cells | 513118 (13.6%) |
| Duplicate rows | 23 (< 0.1%) |
| Total size in memory | 94.5 MiB |
| Average record size in memory | 553.6 B |
Variables types
| NUM | 11 |
|---|---|
| CAT | 9 |
| BOOL | 1 |
Reproduction info
| Date of analysis | 2020-08-30 15:38:51.205757 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
| Dataset has 23 (< 0.1%) duplicate rows | Warning |
batsman has a high cardinality: 516 distinct values | Warning |
batsman_runs has 70845 (39.6%) zeros | Zeros |
bowler has a high cardinality: 405 distinct values | Warning |
bye_runs is highly skewed (γ1 = 29.90100376) | Skewed |
bye_runs has 178598 (99.7%) zeros | Zeros |
dismissal_kind has 170244 (95.1%) missing values | Missing |
extra_runs has 169541 (94.7%) zeros | Zeros |
fielder has 172630 (96.4%) missing values | Missing |
fielder has a high cardinality: 500 distinct values | Warning |
legbye_runs has 176141 (98.4%) zeros | Zeros |
noball_runs is highly skewed (γ1 = 24.48372843) | Skewed |
noball_runs has 178364 (99.6%) zeros | Zeros |
non_striker has a high cardinality: 511 distinct values | Warning |
player_dismissed has 170244 (95.1%) missing values | Missing |
player_dismissed has a high cardinality: 488 distinct values | Warning |
total_runs has 63002 (35.2%) zeros | Zeros |
wide_runs has 173673 (97.0%) zeros | Zeros |
total_runs is highly correlated with batsman_runs | High Correlation |
batsman_runs is highly correlated with total_runs | High Correlation |
ball
Real number (ℝ≥0)
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.615586504 |
|---|---|
| Minimum | 1 |
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.806965975 |
|---|---|
| Coefficient of variation (CV) | 0.4997711915 |
| Kurtosis | -1.083107949 |
| Mean | 3.615586504 |
| Median Absolute Deviation (MAD) | 1.569640941 |
| Skewness | 0.09612230007 |
| Sum | 647472 |
| Variance | 3.265126035 |
| Value | Count | Frequency (%) | |
| 1 | 29047 | 16.2% | |
| 2 | 28963 | 16.2% | |
| 3 | 28878 | 16.1% | |
| 4 | 28812 | 16.1% | |
| 5 | 28720 | 16.0% | |
| 6 | 28628 | 16.0% | |
| 7 | 5113 | 2.9% | |
| 8 | 795 | 0.4% | |
| 9 | 122 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 29047 | 16.2% | |
| 2 | 28963 | 16.2% | |
| 3 | 28878 | 16.1% | |
| 4 | 28812 | 16.1% | |
| 5 | 28720 | 16.0% |
| Value | Count | Frequency (%) | |
| 9 | 122 | 0.1% | |
| 8 | 795 | 0.4% | |
| 7 | 5113 | 2.9% | |
| 6 | 28628 | 16.0% | |
| 5 | 28720 | 16.0% |
| Distinct count | 516 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| V Kohli | 4211 |
|---|---|
| SK Raina | 4044 |
| RG Sharma | 3816 |
| S Dhawan | 3776 |
| G Gambhir | 3524 |
| Other values (511) |
| Value | Count | Frequency (%) | |
| V Kohli | 4211 | 2.4% | |
| SK Raina | 4044 | 2.3% | |
| RG Sharma | 3816 | 2.1% | |
| S Dhawan | 3776 | 2.1% | |
| G Gambhir | 3524 | 2.0% | |
| RV Uthappa | 3492 | 1.9% | |
| DA Warner | 3398 | 1.9% | |
| MS Dhoni | 3318 | 1.9% | |
| AM Rahane | 3215 | 1.8% | |
| CH Gayle | 3131 | 1.7% | |
| Other values (506) | 143153 | 79.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 20 |
|---|---|
| Mean length | 9.318967154 |
| Min length | 5 |
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.246864495 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros | 70845 |
| Zeros (%) | 39.6% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.608270266 |
|---|---|
| Coefficient of variation (CV) | 1.289851682 |
| Kurtosis | 1.632692902 |
| Mean | 1.246864495 |
| Median Absolute Deviation (MAD) | 1.1727085 |
| Skewness | 1.582522721 |
| Sum | 223286 |
| Variance | 2.586533248 |
| Value | Count | Frequency (%) | |
| 0 | 70845 | 39.6% | |
| 1 | 67523 | 37.7% | |
| 4 | 20392 | 11.4% | |
| 2 | 11471 | 6.4% | |
| 6 | 8170 | 4.6% | |
| 3 | 587 | 0.3% | |
| 5 | 79 | < 0.1% | |
| 7 | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 70845 | 39.6% | |
| 1 | 67523 | 37.7% | |
| 2 | 11471 | 6.4% | |
| 3 | 587 | 0.3% | |
| 4 | 20392 | 11.4% |
| Value | Count | Frequency (%) | |
| 7 | 11 | < 0.1% | |
| 6 | 8170 | 4.6% | |
| 5 | 79 | < 0.1% | |
| 4 | 20392 | 11.4% | |
| 3 | 587 | 0.3% |
batting_team
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Mumbai Indians | |
|---|---|
| Kings XI Punjab | |
| Royal Challengers Bangalore | |
| Kolkata Knight Riders | |
| Chennai Super Kings | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| Mumbai Indians | 22619 | 12.6% | |
| Kings XI Punjab | 20931 | 11.7% | |
| Royal Challengers Bangalore | 20908 | 11.7% | |
| Kolkata Knight Riders | 20858 | 11.6% | |
| Chennai Super Kings | 19762 | 11.0% | |
| Delhi Daredevils | 18786 | 10.5% | |
| Rajasthan Royals | 17292 | 9.7% | |
| Sunrisers Hyderabad | 12908 | 7.2% | |
| Deccan Chargers | 9034 | 5.0% | |
| Pune Warriors | 5443 | 3.0% | |
| Other values (5) | 10537 | 5.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 27 |
|---|---|
| Mean length | 17.98253275 |
| Min length | 13 |
| Distinct count | 405 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Harbhajan Singh | 3451 |
|---|---|
| A Mishra | 3172 |
| PP Chawla | 3157 |
| R Ashwin | 3016 |
| SL Malinga | 2974 |
| Other values (400) |
| Value | Count | Frequency (%) | |
| Harbhajan Singh | 3451 | 1.9% | |
| A Mishra | 3172 | 1.8% | |
| PP Chawla | 3157 | 1.8% | |
| R Ashwin | 3016 | 1.7% | |
| SL Malinga | 2974 | 1.7% | |
| DJ Bravo | 2711 | 1.5% | |
| B Kumar | 2707 | 1.5% | |
| P Kumar | 2637 | 1.5% | |
| UT Yadav | 2605 | 1.5% | |
| SP Narine | 2600 | 1.5% | |
| Other values (395) | 150048 | 83.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 17 |
|---|---|
| Mean length | 9.464836552 |
| Min length | 5 |
bowling_team
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Mumbai Indians | |
|---|---|
| Royal Challengers Bangalore | |
| Kolkata Knight Riders | |
| Kings XI Punjab | |
| Chennai Super Kings | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| Mumbai Indians | 22517 | 12.6% | |
| Royal Challengers Bangalore | 21236 | 11.9% | |
| Kolkata Knight Riders | 20940 | 11.7% | |
| Kings XI Punjab | 20782 | 11.6% | |
| Chennai Super Kings | 19556 | 10.9% | |
| Delhi Daredevils | 18725 | 10.5% | |
| Rajasthan Royals | 17382 | 9.7% | |
| Sunrisers Hyderabad | 12779 | 7.1% | |
| Deccan Chargers | 9039 | 5.0% | |
| Pune Warriors | 5457 | 3.0% | |
| Other values (5) | 10665 | 6.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 27 |
|---|---|
| Mean length | 18.00383632 |
| Min length | 13 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.004936396431 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros | 178598 |
| Zeros (%) | 99.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1164798284 |
|---|---|
| Coefficient of variation (CV) | 23.59612523 |
| Kurtosis | 976.9608814 |
| Mean | 0.004936396431 |
| Median Absolute Deviation (MAD) | 0.009846329864 |
| Skewness | 29.90100376 |
| Sum | 884 |
| Variance | 0.01356755041 |
| Value | Count | Frequency (%) | |
| 0 | 178598 | 99.7% | |
| 1 | 324 | 0.2% | |
| 4 | 123 | 0.1% | |
| 2 | 31 | < 0.1% | |
| 3 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 178598 | 99.7% | |
| 1 | 324 | 0.2% | |
| 2 | 31 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 123 | 0.1% |
| Value | Count | Frequency (%) | |
| 4 | 123 | 0.1% | |
| 3 | 2 | < 0.1% | |
| 2 | 31 | < 0.1% | |
| 1 | 324 | 0.2% | |
| 0 | 178598 | 99.7% |
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 170244 |
| Missing (%) | 95.1% |
| Memory size | 1.4 MiB |
| caught | |
|---|---|
| bowled | |
| run out | 852 |
| lbw | 540 |
| stumped | 278 |
| Other values (4) | 235 |
| Value | Count | Frequency (%) | |
| caught | 5348 | 3.0% | |
| bowled | 1581 | 0.9% | |
| run out | 852 | 0.5% | |
| lbw | 540 | 0.3% | |
| stumped | 278 | 0.2% | |
| caught and bowled | 211 | 0.1% | |
| retired hurt | 12 | < 0.1% | |
| hit wicket | 10 | < 0.1% | |
| obstructing the field | 2 | < 0.1% | |
| (Missing) | 170244 | 95.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 21 |
|---|---|
| Mean length | 3.159008923 |
| Min length | 3 |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06703224293 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros | 169541 |
| Zeros (%) | 94.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3425529326 |
|---|---|
| Coefficient of variation (CV) | 5.110271082 |
| Kurtosis | 91.227968 |
| Mean | 0.06703224293 |
| Median Absolute Deviation (MAD) | 0.1269247311 |
| Skewness | 8.234162663 |
| Sum | 12004 |
| Variance | 0.1173425116 |
| Value | Count | Frequency (%) | |
| 0 | 169541 | 94.7% | |
| 1 | 8495 | 4.7% | |
| 2 | 407 | 0.2% | |
| 4 | 348 | 0.2% | |
| 5 | 219 | 0.1% | |
| 3 | 67 | < 0.1% | |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 169541 | 94.7% | |
| 1 | 8495 | 4.7% | |
| 2 | 407 | 0.2% | |
| 3 | 67 | < 0.1% | |
| 4 | 348 | 0.2% |
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 5 | 219 | 0.1% | |
| 4 | 348 | 0.2% | |
| 3 | 67 | < 0.1% | |
| 2 | 407 | 0.2% |
| Distinct count | 500 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 172630 |
| Missing (%) | 96.4% |
| Memory size | 1.4 MiB |
| MS Dhoni | 159 |
|---|---|
| KD Karthik | 152 |
| RV Uthappa | 125 |
| SK Raina | 115 |
| AB de Villiers | 114 |
| Other values (494) |
| Value | Count | Frequency (%) | |
| MS Dhoni | 159 | 0.1% | |
| KD Karthik | 152 | 0.1% | |
| RV Uthappa | 125 | 0.1% | |
| SK Raina | 115 | 0.1% | |
| AB de Villiers | 114 | 0.1% | |
| PA Patel | 97 | 0.1% | |
| RG Sharma | 92 | 0.1% | |
| V Kohli | 90 | 0.1% | |
| KA Pollard | 85 | < 0.1% | |
| WP Saha | 82 | < 0.1% | |
| Other values (489) | 5337 | 3.0% | |
| (Missing) | 172630 | 96.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 21 |
|---|---|
| Mean length | 3.232703068 |
| Min length | 3 |
inning
Real number (ℝ≥0)
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.482951563 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.5020741397 |
|---|---|
| Coefficient of variation (CV) | 0.3385640855 |
| Kurtosis | -1.750085472 |
| Mean | 1.482951563 |
| Median Absolute Deviation (MAD) | 0.5002277651 |
| Skewness | 0.1148252375 |
| Sum | 265564 |
| Variance | 0.2520784418 |
| Value | Count | Frequency (%) | |
| 1 | 92742 | 51.8% | |
| 2 | 86240 | 48.2% | |
| 3 | 50 | < 0.1% | |
| 4 | 38 | < 0.1% | |
| 5 | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 92742 | 51.8% | |
| 2 | 86240 | 48.2% | |
| 3 | 50 | < 0.1% | |
| 4 | 38 | < 0.1% | |
| 5 | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 8 | < 0.1% | |
| 4 | 38 | < 0.1% | |
| 3 | 50 | < 0.1% | |
| 2 | 86240 | 48.2% | |
| 1 | 92742 | 51.8% |
is_super_over
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 1 | 81 |
| Value | Count | Frequency (%) | |
| 0 | 178997 | > 99.9% | |
| 1 | 81 | < 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02113604128 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 176141 |
| Zeros (%) | 98.4% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1949082998 |
|---|---|
| Coefficient of variation (CV) | 9.221608588 |
| Kurtosis | 242.3265243 |
| Mean | 0.02113604128 |
| Median Absolute Deviation (MAD) | 0.04157879189 |
| Skewness | 13.77728696 |
| Sum | 3785 |
| Variance | 0.03798924532 |
| Value | Count | Frequency (%) | |
| 0 | 176141 | 98.4% | |
| 1 | 2558 | 1.4% | |
| 4 | 220 | 0.1% | |
| 2 | 138 | 0.1% | |
| 3 | 17 | < 0.1% | |
| 5 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 176141 | 98.4% | |
| 1 | 2558 | 1.4% | |
| 2 | 138 | 0.1% | |
| 3 | 17 | < 0.1% | |
| 4 | 220 | 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 4 | < 0.1% | |
| 4 | 220 | 0.1% | |
| 3 | 17 | < 0.1% | |
| 2 | 138 | 0.1% | |
| 1 | 2558 | 1.4% |
match_id
Real number (ℝ≥0)
| Distinct count | 756 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1802.252957 |
|---|---|
| Minimum | 1 |
| Maximum | 11415 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 38 |
| Q1 | 190 |
| median | 379 |
| Q3 | 567 |
| 95-th percentile | 11314 |
| Maximum | 11415 |
| Range | 11414 |
| Interquartile range (IQR) | 377 |
Descriptive statistics
| Standard deviation | 3472.322805 |
|---|---|
| Coefficient of variation (CV) | 1.926656739 |
| Kurtosis | 2.245787145 |
| Mean | 1802.252957 |
| Median Absolute Deviation (MAD) | 2493.643808 |
| Skewness | 1.996380528 |
| Sum | 322743855 |
| Variance | 12057025.66 |
| Value | Count | Frequency (%) | |
| 126 | 267 | 0.1% | |
| 34 | 263 | 0.1% | |
| 476 | 262 | 0.1% | |
| 534 | 262 | 0.1% | |
| 388 | 261 | 0.1% | |
| 190 | 259 | 0.1% | |
| 570 | 259 | 0.1% | |
| 536 | 258 | 0.1% | |
| 401 | 258 | 0.1% | |
| 257 | 257 | 0.1% | |
| Other values (746) | 176472 | 98.5% |
| Value | Count | Frequency (%) | |
| 1 | 248 | 0.1% | |
| 2 | 247 | 0.1% | |
| 3 | 218 | 0.1% | |
| 4 | 247 | 0.1% | |
| 5 | 248 | 0.1% |
| Value | Count | Frequency (%) | |
| 11415 | 248 | 0.1% | |
| 11414 | 239 | 0.1% | |
| 11413 | 252 | 0.1% | |
| 11412 | 237 | 0.1% | |
| 11347 | 228 | 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.004182534985 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 178364 |
| Zeros (%) | 99.6% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.07049246775 |
|---|---|
| Coefficient of variation (CV) | 16.85400553 |
| Kurtosis | 1047.984598 |
| Mean | 0.004182534985 |
| Median Absolute Deviation (MAD) | 0.008331717687 |
| Skewness | 24.48372843 |
| Sum | 749 |
| Variance | 0.00496918801 |
| Value | Count | Frequency (%) | |
| 0 | 178364 | 99.6% | |
| 1 | 698 | 0.4% | |
| 2 | 9 | < 0.1% | |
| 5 | 6 | < 0.1% | |
| 3 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 178364 | 99.6% | |
| 1 | 698 | 0.4% | |
| 2 | 9 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 5 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 6 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 2 | 9 | < 0.1% | |
| 1 | 698 | 0.4% | |
| 0 | 178364 | 99.6% |
| Distinct count | 511 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| SK Raina | 4173 |
|---|---|
| S Dhawan | 4090 |
| V Kohli | 4071 |
| RG Sharma | 3858 |
| G Gambhir | 3740 |
| Other values (506) |
| Value | Count | Frequency (%) | |
| SK Raina | 4173 | 2.3% | |
| S Dhawan | 4090 | 2.3% | |
| V Kohli | 4071 | 2.3% | |
| RG Sharma | 3858 | 2.2% | |
| G Gambhir | 3740 | 2.1% | |
| AM Rahane | 3467 | 1.9% | |
| RV Uthappa | 3381 | 1.9% | |
| DA Warner | 3127 | 1.7% | |
| CH Gayle | 3023 | 1.7% | |
| AB de Villiers | 2996 | 1.7% | |
| Other values (501) | 143152 | 79.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 20 |
|---|---|
| Mean length | 9.320647986 |
| Min length | 5 |
over
Real number (ℝ≥0)
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.16248785 |
|---|---|
| Minimum | 1 |
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 10 |
| Q3 | 15 |
| 95-th percentile | 19 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.677684313 |
|---|---|
| Coefficient of variation (CV) | 0.558690391 |
| Kurtosis | -1.183356367 |
| Mean | 10.16248785 |
| Median Absolute Deviation (MAD) | 4.907363011 |
| Skewness | 0.04901758304 |
| Sum | 1819878 |
| Variance | 32.23609916 |
| Value | Count | Frequency (%) | |
| 1 | 9603 | 5.4% | |
| 2 | 9498 | 5.3% | |
| 3 | 9415 | 5.3% | |
| 4 | 9379 | 5.2% | |
| 5 | 9345 | 5.2% | |
| 6 | 9326 | 5.2% | |
| 7 | 9283 | 5.2% | |
| 8 | 9253 | 5.2% | |
| 9 | 9231 | 5.2% | |
| 10 | 9184 | 5.1% | |
| Other values (10) | 85561 | 47.8% |
| Value | Count | Frequency (%) | |
| 1 | 9603 | 5.4% | |
| 2 | 9498 | 5.3% | |
| 3 | 9415 | 5.3% | |
| 4 | 9379 | 5.2% | |
| 5 | 9345 | 5.2% |
| Value | Count | Frequency (%) | |
| 20 | 6738 | 3.8% | |
| 19 | 7866 | 4.4% | |
| 18 | 8387 | 4.7% | |
| 17 | 8648 | 4.8% | |
| 16 | 8761 | 4.9% |
penalty_runs
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 5 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 179076 | > 99.9% | |
| 5 | 2 | < 0.1% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 488 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 170244 |
| Missing (%) | 95.1% |
| Memory size | 1.4 MiB |
| SK Raina | 162 |
|---|---|
| RG Sharma | 155 |
| RV Uthappa | 153 |
| V Kohli | 143 |
| S Dhawan | 137 |
| Other values (482) |
| Value | Count | Frequency (%) | |
| SK Raina | 162 | 0.1% | |
| RG Sharma | 155 | 0.1% | |
| RV Uthappa | 153 | 0.1% | |
| V Kohli | 143 | 0.1% | |
| S Dhawan | 137 | 0.1% | |
| G Gambhir | 136 | 0.1% | |
| KD Karthik | 135 | 0.1% | |
| PA Patel | 126 | 0.1% | |
| AM Rahane | 116 | 0.1% | |
| AT Rayudu | 115 | 0.1% | |
| Other values (477) | 7456 | 4.2% | |
| (Missing) | 170244 | 95.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 20 |
|---|---|
| Mean length | 3.3134165 |
| Min length | 3 |
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.313896738 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 63002 |
| Zeros (%) | 35.2% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.605421643 |
|---|---|
| Coefficient of variation (CV) | 1.221878095 |
| Kurtosis | 1.640138506 |
| Mean | 1.313896738 |
| Median Absolute Deviation (MAD) | 1.180615196 |
| Skewness | 1.556932828 |
| Sum | 235290 |
| Variance | 2.57737865 |
| Value | Count | Frequency (%) | |
| 1 | 73059 | 40.8% | |
| 0 | 63002 | 35.2% | |
| 4 | 20599 | 11.5% | |
| 2 | 13125 | 7.3% | |
| 6 | 8148 | 4.5% | |
| 3 | 688 | 0.4% | |
| 5 | 339 | 0.2% | |
| 8 | 64 | < 0.1% | |
| 7 | 38 | < 0.1% | |
| 10 | 16 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 63002 | 35.2% | |
| 1 | 73059 | 40.8% | |
| 2 | 13125 | 7.3% | |
| 3 | 688 | 0.4% | |
| 4 | 20599 | 11.5% |
| Value | Count | Frequency (%) | |
| 10 | 16 | < 0.1% | |
| 8 | 64 | < 0.1% | |
| 7 | 38 | < 0.1% | |
| 6 | 8148 | 4.5% | |
| 5 | 339 | 0.2% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03672142865 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 173673 |
| Zeros (%) | 97.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2511611312 |
|---|---|
| Coefficient of variation (CV) | 6.839633981 |
| Kurtosis | 191.6858792 |
| Mean | 0.03672142865 |
| Median Absolute Deviation (MAD) | 0.07122617718 |
| Skewness | 11.66307776 |
| Sum | 6576 |
| Variance | 0.06308191384 |
| Value | Count | Frequency (%) | |
| 0 | 173673 | 97.0% | |
| 1 | 4915 | 2.7% | |
| 2 | 230 | 0.1% | |
| 5 | 208 | 0.1% | |
| 3 | 47 | < 0.1% | |
| 4 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 173673 | 97.0% | |
| 1 | 4915 | 2.7% | |
| 2 | 230 | 0.1% | |
| 3 | 47 | < 0.1% | |
| 4 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 208 | 0.1% | |
| 4 | 5 | < 0.1% | |
| 3 | 47 | < 0.1% | |
| 2 | 230 | 0.1% | |
| 1 | 4915 | 2.7% |
First rows
| ball | batsman | batsman_runs | batting_team | bowler | bowling_team | bye_runs | dismissal_kind | extra_runs | fielder | inning | is_super_over | legbye_runs | match_id | noball_runs | non_striker | over | penalty_runs | player_dismissed | total_runs | wide_runs | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | DA Warner | 0 | Sunrisers Hyderabad | TS Mills | Royal Challengers Bangalore | 0 | NaN | 0 | NaN | 1 | 0 | 0 | 1 | 0 | S Dhawan | 1 | 0 | NaN | 0 | 0 |
| 1 | 2 | DA Warner | 0 | Sunrisers Hyderabad | TS Mills | Royal Challengers Bangalore | 0 | NaN | 0 | NaN | 1 | 0 | 0 | 1 | 0 | S Dhawan | 1 | 0 | NaN | 0 | 0 |
| 2 | 3 | DA Warner | 4 | Sunrisers Hyderabad | TS Mills | Royal Challengers Bangalore | 0 | NaN | 0 | NaN | 1 | 0 | 0 | 1 | 0 | S Dhawan | 1 | 0 | NaN | 4 | 0 |
| 3 | 4 | DA Warner | 0 | Sunrisers Hyderabad | TS Mills | Royal Challengers Bangalore | 0 | NaN | 0 | NaN | 1 | 0 | 0 | 1 | 0 | S Dhawan | 1 | 0 | NaN | 0 | 0 |
| 4 | 5 | DA Warner | 0 | Sunrisers Hyderabad | TS Mills | Royal Challengers Bangalore | 0 | NaN | 2 | NaN | 1 | 0 | 0 | 1 | 0 | S Dhawan | 1 | 0 | NaN | 2 | 2 |
| 5 | 6 | S Dhawan | 0 | Sunrisers Hyderabad | TS Mills | Royal Challengers Bangalore | 0 | NaN | 0 | NaN | 1 | 0 | 0 | 1 | 0 | DA Warner | 1 | 0 | NaN | 0 | 0 |
| 6 | 7 | S Dhawan | 0 | Sunrisers Hyderabad | TS Mills | Royal Challengers Bangalore | 0 | NaN | 1 | NaN | 1 | 0 | 1 | 1 | 0 | DA Warner | 1 | 0 | NaN | 1 | 0 |
| 7 | 1 | S Dhawan | 1 | Sunrisers Hyderabad | A Choudhary | Royal Challengers Bangalore | 0 | NaN | 0 | NaN | 1 | 0 | 0 | 1 | 0 | DA Warner | 2 | 0 | NaN | 1 | 0 |
| 8 | 2 | DA Warner | 4 | Sunrisers Hyderabad | A Choudhary | Royal Challengers Bangalore | 0 | NaN | 0 | NaN | 1 | 0 | 0 | 1 | 0 | S Dhawan | 2 | 0 | NaN | 4 | 0 |
| 9 | 3 | DA Warner | 0 | Sunrisers Hyderabad | A Choudhary | Royal Challengers Bangalore | 0 | NaN | 1 | NaN | 1 | 0 | 0 | 1 | 1 | S Dhawan | 2 | 0 | NaN | 1 | 0 |
Last rows
| ball | batsman | batsman_runs | batting_team | bowler | bowling_team | bye_runs | dismissal_kind | extra_runs | fielder | inning | is_super_over | legbye_runs | match_id | noball_runs | non_striker | over | penalty_runs | player_dismissed | total_runs | wide_runs | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179068 | 3 | RA Jadeja | 2 | Chennai Super Kings | JJ Bumrah | Mumbai Indians | 0 | NaN | 0 | NaN | 2 | 0 | 0 | 11415 | 0 | SR Watson | 19 | 0 | NaN | 2 | 0 |
| 179069 | 4 | RA Jadeja | 0 | Chennai Super Kings | JJ Bumrah | Mumbai Indians | 0 | NaN | 0 | NaN | 2 | 0 | 0 | 11415 | 0 | SR Watson | 19 | 0 | NaN | 0 | 0 |
| 179070 | 5 | RA Jadeja | 2 | Chennai Super Kings | JJ Bumrah | Mumbai Indians | 0 | NaN | 0 | NaN | 2 | 0 | 0 | 11415 | 0 | SR Watson | 19 | 0 | NaN | 2 | 0 |
| 179071 | 6 | RA Jadeja | 4 | Chennai Super Kings | JJ Bumrah | Mumbai Indians | 4 | NaN | 4 | NaN | 2 | 0 | 0 | 11415 | 0 | SR Watson | 19 | 0 | NaN | 8 | 0 |
| 179072 | 1 | SR Watson | 1 | Chennai Super Kings | SL Malinga | Mumbai Indians | 0 | NaN | 0 | NaN | 2 | 0 | 0 | 11415 | 0 | RA Jadeja | 20 | 0 | NaN | 1 | 0 |
| 179073 | 2 | RA Jadeja | 1 | Chennai Super Kings | SL Malinga | Mumbai Indians | 0 | NaN | 0 | NaN | 2 | 0 | 0 | 11415 | 0 | SR Watson | 20 | 0 | NaN | 1 | 0 |
| 179074 | 3 | SR Watson | 2 | Chennai Super Kings | SL Malinga | Mumbai Indians | 0 | NaN | 0 | NaN | 2 | 0 | 0 | 11415 | 0 | RA Jadeja | 20 | 0 | NaN | 2 | 0 |
| 179075 | 4 | SR Watson | 1 | Chennai Super Kings | SL Malinga | Mumbai Indians | 0 | run out | 0 | KH Pandya | 2 | 0 | 0 | 11415 | 0 | RA Jadeja | 20 | 0 | SR Watson | 1 | 0 |
| 179076 | 5 | SN Thakur | 2 | Chennai Super Kings | SL Malinga | Mumbai Indians | 0 | NaN | 0 | NaN | 2 | 0 | 0 | 11415 | 0 | RA Jadeja | 20 | 0 | NaN | 2 | 0 |
| 179077 | 6 | SN Thakur | 0 | Chennai Super Kings | SL Malinga | Mumbai Indians | 0 | lbw | 0 | NaN | 2 | 0 | 0 | 11415 | 0 | RA Jadeja | 20 | 0 | SN Thakur | 0 | 0 |